home *** CD-ROM | disk | FTP | other *** search
/ SGI Freeware 2002 November / SGI Freeware 2002 November - Disc 3.iso / dist / fw_mysql.idb / usr / freeware / share / mysql-test / t / rpl000018.test.z / rpl000018.test
Text File  |  2002-10-07  |  434b  |  20 lines
  1. connect (master,localhost,root,,test,0,mysql-master.sock);
  2. connect (slave,localhost,root,,test,0,mysql-slave.sock);
  3. connection slave;
  4. reset slave;
  5. slave start;
  6. connection master;
  7. show master logs;
  8. drop table if exists t1;
  9. create table t1(n int);
  10. insert into t1 values (3351);
  11. save_master_pos;
  12. connection slave;
  13. sync_with_master;
  14. select * from t1;
  15. connection master;
  16. drop table t1;
  17. save_master_pos;
  18. connection slave;
  19. sync_with_master;
  20.